To currency operator

Crystal syntax.

Usage

$x

Converts x from number to currency.

Examples

The following examples are applicable to Crystal syntax.

Note: They all assume the following format (set in the Number tab of the Format Editor): Decimal places = (1.00), Negative sign = (345.00-), Currency symbol = (Float), and Thousands Separator = (1,000.00).

$12345678

Returns $12,345,678.00.

$(123 * 456)

Returns $56,088.00

$({file.QUANTITY} * 3)

Returns $42.00, where {file.QUANTITY} = 14.

$({file.MILES} * {file.PLEDGE})

$27.95, where {file.MILES} = 13 and {file.PLEDGE} = 2.15.

Note: $ * $ = error. You can not multiply a dollar with a dollar.